date = ['3月月考成绩单',
        '序号', '姓名', '语文', '英语', '数学', '历史', '地理', '物理', '化学', '总分', '名次',
        '1', '王利奎', '67', '85', '63', '72', '57', '75', '58', '477', '1',
        '2', '杜娅琪', '67', '72', '85', '67', '58', '69', '54', '471', '2',
        '3', '牛震', '80', '65', '77', '43', '65', '88', '53', '470', '3',
        '4', '宋瑶', '43', '73', '81', '78', '52', '67', '68', '462', '4',
        '5', '韩妍妍', '51', '88', '82', '55', '41', '42', '75', '434', '5',
        '6', '李巧慧', '53', '69', '45', '42', '67', '71', '75', '422', '6',
        '7', '孙艺凡', '51', '78', '72', '60', '48', '64', '48', '421', '7',
        '8', '魏毓蕾', '60', '64', '68', '60', '54', '57', '57', '420', '8',
        '9', '魏庆蕊', '57', '49', '94', '62', '47', '58', '51', '418', '9',
        '10', '董梦毅', '46', '78', '70', '66', '56', '55', '39', '411', '10',
        '11', '许铖', '47', '42', '75', '80', '58', '61', '48', '411', '11',
        '12', '曹萌', '54', '75', '36', '61', '58', '69', '56', '409', '12',
        '13', '朱贺祥', '61', '30', '94', '60', '45', '68', '35', '393', '13',
        '14', '孟金景', '54.5', '70', '60', '42', '40', '62', '47', '375.5', '14',
        '15', '郭乃柄', '43', '54', '60', '62', '55', '49', '50', '373', '15',
        '16', '韩梦晴', '54', '72', '54', '62', '30', '37', '57', '366', '16',
        '17', '罗琳', '51', '73', '45', '58', '44', '55', '34', '360', '17',
        '18', '王梦威', '46', '49', '53', '54', '67', '46', '43', '358', '18',
        '19', '郝潇爽', '45', '57', '61', '60', '43', '45', '46', '357', '19',
        '20', '大王瑞娜', '54', '52', '26', '54', '46', '65', '56', '353', '20',
        '21', '刘园园', '43', '63', '53', '52', '32', '66', '37', '346', '21',
        '22', '王俊杰', '45', '62', '56', '44', '40', '54', '36', '338', '22',
        '23', '徐艺帆', '58', '57', '58', '54', '39', '29', '43', '338', '23',
        '24', '史婉玉', '45', '33', '91', '54', '30', '46', '38', '337', '24',
        '25', '李世文', '50', '54', '66', '50', '36', '35', '42', '333', '25',
        '26', '王晨雨', '53', '56', '62', '56', '29', '34', '36', '326', '26',
        '27', '王庆昆', '37', '53', '54', '52', '40', '31', '54', '321', '27',
        '28', '尚立艳', '52', '30', '45', '44', '45', '49', '49', '314', '28',
        '29', '陈梦娜', '58', '50', '35', '50', '42', '36', '41', '312', '29',
        '30', '李冬阳', '44', '67', '30', '52', '36', '44', '35', '308', '30',
        '31', '袁本科', '41', '38', '69', '46', '30', '45', '33', '302', '31',
        '32', '潘佳慧', '53', '56', '34', '48', '32', '50', '23', '296', '32',
        '33', '张梦茹', '38.5', '58', '23', '49', '44', '41', '42', '295.5', '33',
        '34', '祁雨露', '42', '46', '36', '54', '40', '43', '34', '295', '34',
        '35', '李晴', '52', '44', '26', '42', '38', '43', '48', '293', '35',
        '36', '蔡学智', '59', '27', '39', '62', '36', '28', '39', '290', '36',
        '37', '任智慧', '59', '32', '45', '50', '36', '24', '36', '282', '37',
        '38', '郝潇梦', '44', '38', '72', '51', '22', '27', '25', '279', '38',
        '39', '李焦娣', '42', '60', '34', '48', '27', '27', '41', '279', '39',
        '40', '小王瑞娜', '46', '37', '38.5', '46', '20', '34', '46', '266.5', '40',
        '41', '余骏杰', '54', '33', '47', '22', '26', '41', '39', '262', '41',
        '42', '艾景童', '55', '48', '26', '54', '25', '21', '27', '256', '42',
        '43', '和梦宇', '47', '33', '27', '12', '31', '39', '57', '246', '43',
        '44', '许彦东', '40', '41', '51', '30', '20', '27', '22', '231', '44',
        '45', '王学硕', '44', '27', '54', '26', '18', '20', '29', '218', '45',
        '46', '刘冠男', '43', '35', '21', '47', '24', '11', '33', '214', '46',
        '47', '胡德帅', '48', '30', '18', '25', '32', '20', '25', '198', '47',
        '48', '李书怡', '0', '0', '0', '0', '0', '0', '0', '0', '48']

成绩结果列表数据 =[
 ['1', '王利奎', '67', '85', '63', '72', '57', '75', '58', '477', '1'],
 ['2', '杜娅琪', '67', '72', '85', '67', '58', '69', '54', '471', '2'],
 ['3', '牛震', '80', '65', '77', '43', '65', '88', '53', '470', '3'],
 ['4', '宋瑶', '43', '73', '81', '78', '52', '67', '68', '462', '4'],
 ['5', '韩妍妍', '51', '88', '82', '55', '41', '42', '75', '434', '5'],
 ['6', '李巧慧', '53', '69', '45', '42', '67', '71', '75', '422', '6'],
 ['7', '孙艺凡', '51', '78', '72', '60', '48', '64', '48', '421', '7'],
 ['8', '魏毓蕾', '60', '64', '68', '60', '54', '57', '57', '420', '8'],
 ['9', '魏庆蕊', '57', '49', '94', '62', '47', '58', '51', '418', '9'],
 ['10', '董梦毅', '46', '78', '70', '66', '56', '55', '39', '411', '10'],
 ['11', '许铖', '47', '42', '75', '80', '58', '61', '48', '411', '11'],
 ['12', '曹萌', '54', '75', '36', '61', '58', '69', '56', '409', '12'],
 ['13', '朱贺祥', '61', '30', '94', '60', '45', '68', '35', '393', '13'],
 ['14', '孟金景', '54.5', '70', '60', '42', '40', '62', '47', '375.5', '14'],
 ['15', '郭乃柄', '43', '54', '60', '62', '55', '49', '50', '373', '15'],
 ['16', '韩梦晴', '54', '72', '54', '62', '30', '37', '57', '366', '16'],
 ['17', '罗琳', '51', '73', '45', '58', '44', '55', '34', '360', '17'],
 ['18', '王梦威', '46', '49', '53', '54', '67', '46', '43', '358', '18'],
 ['19', '郝潇爽', '45', '57', '61', '60', '43', '45', '46', '357', '19'],
 ['20', '大王瑞娜', '54', '52', '26', '54', '46', '65', '56', '353', '20'],
 ['21', '刘园园', '43', '63', '53', '52', '32', '66', '37', '346', '21'],
 ['22', '王俊杰', '45', '62', '56', '44', '40', '54', '36', '338', '22'],
 ['23', '徐艺帆', '58', '57', '58', '54', '39', '29', '43', '338', '23'],
 ['24', '史婉玉', '45', '33', '91', '54', '30', '46', '38', '337', '24'],
 ['25', '李世文', '50', '54', '66', '50', '36', '35', '42', '333', '25'],
 ['26', '王晨雨', '53', '56', '62', '56', '29', '34', '36', '326', '26'],
 ['27', '王庆昆', '37', '53', '54', '52', '40', '31', '54', '321', '27'],
 ['28', '尚立艳', '52', '30', '45', '', '', '', '', '314', '28'],
 ['29', '陈梦娜', '58', '50', '35', '', '', '', '', '312', '29'],
 ['30', '李冬阳', '44', '67', '30', '', '', '', '', '308', '30'],
 ['31', '袁本科', '41', '38', '69', '46', '30', '45', '33', '302', '31'],
 ['32', '潘佳慧', '53', '56', '34', '48', '32', '50', '23', '296', '32'],
 ['33', '张梦茹', '38.5', '58', '23', '49', '44', '41', '42', '295.5', '33'],
 ['34', '祁雨露', '42', '46', '36', '54', '40', '43', '34', '295', '34'],
 ['35', '李晴', '52', '44', '26', '42', '38', '43', '48', '293', '35'],
 ['36', '蔡学智', '59', '27', '39', '62', '36', '28', '39', '290', '36'],
 ['37', '任智慧', '59', '32', '45', '50', '36', '24', '36', '282', '37'],
 ['38', '', '', '', '', '', '', '', '', '', ''],
 ['39', '', '', '', '', '', '', '', '', '', ''],
 ['40', '', '', '', '', '', '', '', '', '', ''],
 ['41', '', '', '', '', '', '', '', '', '', ''],
 ['42', '', '', '', '', '', '', '', '', '', ''],
 ['43', '', '', '', '', '', '', '', '', '', ''],
 ['44', '', '', '', '', '', '', '', '', '', ''],
 ['45', '', '', '', '', '', '', '', '', '', ''],
 ['46', '', '', '', '', '', '', '', '', '', ''],
 ['47', '', '', '', '', '', '', '', '', '', ''],
 ['48', '', '', '', '', '', '', '', '', '', '']
 ]



del date[0]
dateList = []
for i in range(0, int(len(date) / 11)):
    strList = list()
    for j in range(0, 11):
        strList.insert(j, date[i * 11 + j])
    print(strList)
    # dateList.insert(strList)
    dateList.append(strList)
del dateList[0]
print(dateList)


for i in  range(0,len(成绩结果列表数据)):
        for j in range(0,len(成绩结果列表数据[i])):
                if 成绩结果列表数据[i][j] =='':
                        Excel.Cs_SetCellBackground(self, Excel文件, "", j + 1, str(i + 2), "#f8e71c", 0, skip_err=0,
                                                   delay_before=0, delay_after=0)
                        continue
                Excel.Cs_WriteCellV2(self, Excel文件, "",  j+1,str(i+2), 成绩结果列表数据[i][j], 0, skip_err=0, delay_before=0, delay_after=0)
                if 成绩结果列表数据[i][j] != dateList[i][j]:
                        Excel.Cs_SetCellBackground(self, Excel文件, "", j+1 , str(i +2), "#f8e71c", 0, skip_err=0,
                                                   delay_before=0, delay_after=0)
                        # Basic.DebugOutput(self, 成绩结果列表数据[i][j]+":不相等:"+dateList[i][j])
                        # print(成绩结果列表数据[i][j]+":不相等:"+dateList[i][j])
                else:
                        # print(成绩结果列表数据[i][j] + ":==:" + dateList[i][j])
                        Basic.DebugOutput(self, 成绩结果列表数据[i][j] + ":==:" + dateList[i][j])
# 比较各科成绩大小,并获取最高成绩
'''
for i in  range(0,len(成绩结果列表数据)):
        for j in range(0,len(成绩结果列表数据[i])):
                # 语文成绩 Chinese Math English History Geography Chemistry
                if i == 2:
                        Chinese_max=0
                        if Chinese_max < 成绩结果列表数据[i]:
                                Chinese_max = 成绩结果列表数据[i]
                        else:
                                成绩结果列表数据[i]
                        if


                # 英语成绩 English
                elif i == 3:
                # 数学成绩 Math
                elif i == 4:
                # 历史成绩 History
                elif i == 5:
                # 地理成绩 Geography
                elif i == 6:
                # 物理成绩 Physics
                elif i == 7:
                # 化学成绩 Chemistry
                elif i == 8:

'''



